package com.download.web.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.download.web.entity.BusAdvertising;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface AdvertisingMapper extends BaseMapper<BusAdvertising> {

    @Select("select * from bus_advertising limit #{pageIndex},#{pageSize}")
    List<BusAdvertising> advertisingList(@Param("pageIndex") Integer pageIndex,@Param("pageSize") Integer pageSize);

    @Select("select count(1) from bus_advertising ")
    Integer advertisingCount();

}
